Re: How can I.. - Mailing list pgsql-admin

From Chris Ruprecht
Subject Re: How can I..
Date
Msg-id p05101003b800c6cbae3f@[192.168.0.4]
Whole thread Raw
In response to How can I..  ("Eric Day" <eday@sandibooks.com>)
List pgsql-admin
Eric,

>How do I create a stored procedure which would return a few records with a
>few columns each ?
>
>Regards,
>Eric


Create a temp table, delete all it's records. Then have run your
procedure which will create records in the temp table. You have
access to the records in the temp table from your calling procedure.
Sorry, but there is no data type 'record' which can be used to return
a records (row, tuple, etc.) in PostGreSQL at the moment.

Best regards,
Chris
--
--
Chris Ruprecht
Network grunt and bit pusher extraordinaíre

_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com


pgsql-admin by date:

Previous
From: "Eric Day"
Date:
Subject: How can I..
Next
From: Chris Ruprecht
Date:
Subject: Re: [Solution] PG 7.1.3 & MacOS X (10.1)